Ask Question
SAP C_BW4H_2404 Practice Test - Questions Answers
Add to Whishlist
List of questions
Question 1
You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW/4HANA. Real-time reporting requirements have now changed you are asked to persist the data in SAP BW/4HANA.
Which objects are created when using the 'Generate Data Flow' function in the Open ODS View editor? Note: There are 3 correct answers to this question.
DataStore object (advanced)
SAP HANA calculation view
Transformation
Data source
CompositeProvider
Question 2
Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question.
Create linked components.
Include fewer drill-down characteristics in the initial view.
Use matory characteristic value variables.
Use the include mode within filter restrictions.
Use the dereference option for reusable filters.
Question 3
An upper-level CompositeProvider compares current values with historic values based on a union operation. The current values are provided by a DataStore object (advanced) that is updated daily. Historic values are provided by a lower-level CompositeProvider that combines different open ODS views from DataSources.
What can you do to improve the performance of the BW queries that use the upper-level CompositeProvider? Note: There are 2 correct answers to this question.
Replace the lower-level CompositeProvider with a new DataStore object (advanced) fill it with the same combination of historic data.
Use a join node instead of the Union node in the upper-level CompositeProvider.
Replace the DataStore object (advanced) for current data by an Open ODS view that accesses the current data directly from the source system.
Use the 'Generate Dataflow' feature for the Open ODS views load the historic data to the new generated DataStore objects (advanced).
Question 4
What are some of the variable types in a BW query that can use the processing type SAP HANA Exit? Note: There are 2 correct answers to this question.
Hierarchy node
Formula
Text
Characteristic value
Question 5
What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question.
By using a BW query (update value set by query)
By accessing an SAP HANA HDI Calculation View of data category Dimension
By using a transformation data transfer process (DTP)
By entering the values manually
By referencing a table
Question 6
Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.
Position of child nodes
Sort direction
Exp to level
Display text nodes
Time dependency
Question 7
What is the maximum number of reference characteristics that can be used for one key figure with a multi-dimensional exception aggregation in a BW query?
10
7
5
3
Question 8
In a BW query with cells you need to overwrite the initial definition of a cell. Which cell types can you use? Note: There are 2 correct answers to this question.
Reference cell
Formula cell
Selection cell
Help cell
Question 9
You would like to highlight the deviation from predefined threshold values for a key figure visualize it in SAP Analysis for Microsoft Office. Which BW query feature do you use?
Formula cell
Exception
Key figure property
Condition
Question 10
You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue.
Using key figure properties in the BW query which two scenarios regarding result presentation can be achieved? Note: There are 2 correct answers to this question.
One result row with the sales revenue sum of all 100 customers
One result row with the sales revenue sum of the top 10 customers a second result row with the sales revenue sum of all 100 customers
One result row with the sales revenue sum of the top 10 customers
One result row with the sales revenue sum of the top 10 customers a second result row with the sales revenue sum of the other 90 customers
Related questions
Export
If you didn't receive an email within 5 minutes, you should submit a support request to [email protected].
|
BASIC - 1 Month
$
10
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PLUS - 2 Months
$
15
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PRO - 6 Months
$
40
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Selling illegal goods, money scams etc.
Serious attack on a group.
Harassing an individual (including doxing)
Threatening or glorifying violence or serious harm, including self-harm
Nudity/Sexual content
Sexually explicit or suggestive imagery or writing involving minors
Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans
Reusing content without attribution (link and blockquotes)
Not in English or has very bad formatting, grammar, and spelling
Author's credential is offensive, spam, or impersonation
Ex. Illegal content, incomplete question...
Question